<?php

//Rquire MySqlAdapter.
require_once(dirname(__FILE__).'/../db/MySqlAdapter.php');

class securityDBHandler {

 	/*************************************************************************
	*************************      Public Methods     ************************
	*************************************************************************/
	
		//This function returns a table with student details 
		public static function find_security_details($user_id)
		{
			return securityDBHandler::securityDetails($user_id);
		}
		
		
	/*****************       Private Methods        *******************/

	private static function securityDetails($user_id) {
		 $mysql_link = MySqlAdapter::get_mysql_link();
		 
		 $query = securityDBHandler::security_query($user_id);
		 $result = mysql_query($query, $mysql_link);	//Excecute the Query
		 
		return $result;
	}
	
	/*************************************************************************
	*************************   Queires Methods   ****************************
	*************************************************************************/

	private static function security_query($user_id)	
	{
			$query="SELECT *
					 FROM `ohel_shelomo_2012`.`security` 
					 WHERE id=".$user_id;
		return $query;
	}
	
}
?>